﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using DAL;
using System.Data;

namespace BLL
{
    /// <summary>
    /// Author: Sissi Zeng
    /// Date: 2012-08-08 14:50 
    /// get TeacherList from DAL(Teacher)
    /// return to UI
    /// </summary>
    public class TeacherList
    {


        /// <summary>
        /// Constructor
        /// </summary>
        public TeacherList()
        {

        }

        /// <summary>
        /// get list of all column
        /// </summary>
        /// <returns>DataSet</returns>
        public DataSet getList()
        {
            DAL.Teacher dalTeacher = new DAL.Teacher();
            return dalTeacher.getAll();
        }

        /// <summary>
        /// get list by a certain column
        /// </summary>
        /// <param name="colum">column name</param>
        /// <returns>SqlDataReader</returns>
        public SqlDataReader getListBy(string colum)
        {
            DAL.Teacher dalTeacher = new DAL.Teacher();
            return dalTeacher.getListBy(colum);
        }
    }
}
